home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2005 October / PCWOCT05.iso / Software / FromTheMag / XAMPP 1.4.14 / xampp-win32-1.4.14-installer.exe / xampp / php / pear / adodb / tests / test-perf.php < prev    next >
PHP Script  |  2003-10-08  |  959b  |  51 lines
  1. <?php
  2.  
  3. include_once('../adodb-perf.inc.php');
  4.  
  5. error_reporting(E_ALL);
  6. session_start();
  7.  
  8. if (isset($_GET)) {
  9.     foreach($_GET as $k => $v) {
  10.         if (strncmp($k,'test',4) == 0) $_SESSION['_db'] = $k;
  11.     }
  12. } 
  13.  
  14. if (isset($_SESSION['_db'])) {
  15.     $_db = $_SESSION['_db'];
  16.     $_GET[$_db] = 1;
  17.     $$_db = 1;
  18. }
  19.  
  20. echo "<h1>Performance Monitoring</h1>";
  21. include_once('testdatabases.inc.php');
  22.  
  23.  
  24. function testdb($db) 
  25. {
  26.     if (!$db) return;
  27.     echo "<font size=1>";print_r($db->ServerInfo()); echo " user=".$db->user."</font>";
  28.     
  29.     $perf = NewPerfMonitor($db); 
  30.     
  31.     # unit tests
  32.     if (0) {
  33.         //$DB->debug=1;
  34.         echo "Data Cache Size=".$perf->DBParameter('data cache size').'<p>';
  35.         echo $perf->HealthCheck();
  36.         echo($perf->SuspiciousSQL());
  37.         echo($perf->ExpensiveSQL());
  38.         echo($perf->InvalidSQL());
  39.         echo $perf->Tables();
  40.     
  41.         echo "<pre>";
  42.         echo $perf->HealthCheckCLI();
  43.         $perf->Poll(3);
  44.         die();
  45.     }
  46.     
  47.     if ($perf) $perf->UI(3);
  48. }
  49.  
  50. ?>
  51.